Conditional Formats w/ rows

  • Thread starter Thread starter Dominique Feteau
  • Start date Start date
D

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?
 
Hi

A1:A4 ???
Maybe A1:D1 !

Select range A1
Format.ConditionalFormatting - select 'Formula is' and enter the formula
=($C1=1)
Set fill color
OK
Select A1
Copy
Select range A1:D1
PasteSpecial.Formats
You can copy formats down too - condition is adjusted row-wise
 
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
 
Back
Top