Format a whole section if cell=0

C

cassy01

hello, is it possible to format a section of the workbook if a cell i
blank.

For Example:

If G8 = 0 then G8:AA8 will turn completely white.

is this possible ???? :)

many thanks
Ben
 
F

Frank Kabel

Hi
- select G8:AA8
- goto 'Format - Conditional format
- enter the following formula
=$G8=0
- choose your white font format
 
P

Paul Corrado

Use

Format/Conditional Formatting

Select the entire range and

Formula is =$G$8 = 0

Set the Format to change text and background to White
 
Top