Conditional Formats w/ rows

[Dominique Feteau]

How would you set up a group of cells to change yellow if one of the cells
in that group fit the requirements of conditional formatting. E.g:

Account Name Address Billing Method Amount

if the billing method was "1", i want A1:A4 to be changed yellow.

Can that be done?

 

[Arvi Laanemets]

Hi

A1:A4 ???
Maybe A11 !

Select range A1
Format.ConditionalFormatting - select 'Formula is' and enter the formula
=($C1=1)
Set fill color
OK
Select A1
Copy
Select range A11
PasteSpecial.Formats
You can copy formats down too - condition is adjusted row-wise

 

[Julia0001]

Yes, it can be done

You format all the cells with the following (assuming columns are as in your example)

Formula Is: =($C1=1

(Then set the format you want

That way each cell checks column C for its row to see if the value is 1, and applies the format if it is

Hope this helps

Julia