conditional format

[sam]

I have a sheet with 6 columns of data. Starting from
column B to G.I will like when there is data or text in
all column cell for the color to change to say Red. And
if all cells does not have data for color to start as it
is. A macro will be great, since I will be run other
macro on these data.
Thanks in advance.

 

[Norman Harker]

Hi Sam!

Taking row 1 as my base:

Use condition formatting Formula Is
=COUNTA(B1:G1)=6
Press Format
Select Format
OK
OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Norman Harker]

Hi Sam!

Correction to the referencing:

=COUNTA($B1:$G1)=6

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.