How to do a conditional format for multi cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dave wagner - 22 Dec 2005 21:05 GMT

Lets say based on a value in A5 I would like to change the text format for
cells d5:g5 (four columns), what would be the best procedure to do this, can
it be done using conditional format if each cell d5,e5,f5,g5 or is there
another way. By that do I input a conditional format for each cell
d5,e5,f5,g5 (if A5> "xx" then <format>.

A big Thank You for all the help.

dave

Reply to this Message

Pete_UK - 22 Dec 2005 21:14 GMT

Yes, highlight the four cells and apply your conditional format to them
all. You will need to use $A$5 as the reference.

Pete

Reply to this Message

dave wagner - 28 Dec 2005 04:35 GMT

Hi Pete,

This did not work for me. For the "value" I have =$I$8-J54 in the cell, this
is the number of days that has passed. So if 90 days has passed I want to
grey out column k,l,m, and n. This is what I'm trying to do.

I am assuming that the value of 90 is not showing due to the "date" format.
Is there a simple solution that I am missing?

Again, Thanks for your help.
____________________________________________

> Yes, highlight the four cells and apply your conditional format to them
> all. You will need to use $A$5 as the reference.
>
> Pete

Reply to this Message