conditional format

  • Thread starter Thread starter sam
  • Start date Start date
S

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.
 
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.
 
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.
 
Back
Top