View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Barbara Barbara is offline
external usenet poster
 
Posts: 97
Default conditional formatting in Excel 2007 - help, please!

I have a large spreadsheet, with the active data area being cells a4:x8659.
In the A column, I have a formula that evaluates to 1 or 0, depending on
whether the room number in column E has changed from the previous row.

What I *want* to have happen is this:
1) If the value of the cell in the A column for a particular row is 1, set
the color of the cells in that particular row to color #1 (in this case, a
nice pastel yellow);
2) If the value of the cell in the A column for a particular row is 0, set
the color of the cells in that particular row to white.

Have tried to follow the instructions in the Help section, but am not
getting the results I want - yet.

The range of cells to be checked and colored *is* large. Is this a factor in
getting the CF to work?

If I've understood the Help File correctly, this conditional formatting can
be over-ridden by separately and manually-applied cell formatting. Am I
correct on this?

Any help will be appreciated - greatly!

Barbara
--
***************************
Bookaholics of the World, Unite!
You have nothing to lose but your ignorance!
***************************