Format a whole section if cell=0

[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

 

[Frank Kabel]

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

 

[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