For a certain column, there are 3 options that can happen
1. "PAID"
2. "UNDERPAID BY ..." (... is a variable number)
3. "OVERPAID BY ..." (... is a variable number)
I am trying to use conditional formatting to make "PAID" in a green box, "UNDERPAID BY..." in a red box and "OVERPAID BY..." in any colur box.
The problem is with the "UNDERPAID BY ..." and "OVERPAID BY...." as they are variables.
Is there any way around this?
Last edited by Tziggy; 12-09-2008 at 04:35 AM.
Use a formula of
=ISNUMBER(SEARCH("UNDERPAID BY",A2))
in the CF
OK thanks got the colour coding to work
just 1 thing, in some cells, for eg. it will say "UNDERPAID BY R345.60007932" (R is used as currency - Rand)
Formating the cells to 2 decimal places does not change anything.
Is there a way to change it?
Last edited by Tziggy; 12-09-2008 at 04:55 AM.
Presumably you are getting the value from another cell? If so use,
="UNDERPAID BY R" & ROUND(A2,2)
Thank you it works now!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks