LinkBack URL
About LinkBacks
Hi,
If A2 contain value less than 20, then value in B2 should be red colored.
Example:
A2 B2
19 book 20%
Can anyone help me to know how to get it done.
Thx
Tuhin
Hi,
If A2 contain value less than 20, then value in B2 should be red colored.
Example:
A2 B2
19 book 20%
Can anyone help me to know how to get it done.
Thx
Tuhin
Hi
Use Conditional formatting for this.
In Conditional Formatting rules put this.
=AND($A2<>"",$A2<20 >>Choose red color>>OK.
Last edited by Fotis1991; 07-04-2012 at 03:17 AM.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Select B2 to apply the Conditional Format.
Conditional Formatting > New Rule
Select 'Use a formula to determine which cells to format'
In 'Format values where this formula is true' enter:
=$A$2<20
Choose your required format and confirm all dialog boxes.
@ GazP
This will highlight cells, even if these are empties
I salute both of you. It is working !
Thank you so much
By the way, if I want to apply whole column, then?
Example:
A B
10 40%
25 10%
19 10%
Last edited by mshtuhin; 07-04-2012 at 05:18 AM.
Just change your range
Thanks so much Boss :-)
brgds/Tuhin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks