PDA

View Full Version : [SOLVED:] Conditional formatting



Ismael
02-16-2005, 09:23 AM
Hi to all,

I have a simple question in a conditional formatting.

In the attach file you have too columns, what I want is make a conditional formatting in the column c.

Something like that:

everytime that rows in column b is empty make appear a color in column c, is this possible?

if any of you can take a look a that I appreciate.

Thanks,

best regards,

Ismael

Norie
02-16-2005, 09:57 AM
Ismael

Select the numbers in column C.

Goto Format>Conditional Formatting..., select Formula is and enter
=ISBLANK(B4) and then Format... as required.

Ismael
02-16-2005, 10:12 AM
Hi Norie,

It's really easy.

Thanks for the help,

best regards,

Ismael

:beerchug:

Ken Puls
02-16-2005, 10:58 AM
Hi Ismael,

Not sure if you are aware, but you can mark you own threads solved if your question has been answered. It helps keep the forum clean and tidy for us! :yes

Just see the instructions in my sig below!

Ismael
02-16-2005, 11:04 AM
Hi Kplus,

I didn?t now that was possible to mark solve in the question, I already do that for this question, and from here to front I gone to make always.



Thanks for the tip.



Best regards,



Ismael

Zack Barresse
02-16-2005, 11:05 AM
Ismael, great to see you found a solution! :yes

Also, there is no need to post with BB code; just type in your text in a regular format in the reply screen.