Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Conditional Format
I have cells with info like 1/6 and 2/2 etc
Is it possible to have a Conditional Format Formula that will color cells with un-equal numbers (1/6, 3/4 etc) Red and cells with equal numbers (3/3, 1/1 etc) Light Green _______________________________ AWS |
#2
|
|||
|
|||
Do you mean integers and non-integers?
if so you can use conditional formatting with formulae of =A2=INT(A2) and =A2<INT(A2) -- HTH Bob Phillips "AWS" wrote in message ... I have cells with info like 1/6 and 2/2 etc Is it possible to have a Conditional Format Formula that will color cells with un-equal numbers (1/6, 3/4 etc) Red and cells with equal numbers (3/3, 1/1 etc) Light Green _______________________________ AWS |
#3
|
|||
|
|||
"1/3" represents "One of Three"
"2/2" represents "two of two" etc I want the cells with the left hand number smaller than the right to be shown in red, and if they match shown in green _______________________________ AWS "Bob Phillips" wrote: Do you mean integers and non-integers? if so you can use conditional formatting with formulae of =A2=INT(A2) and =A2<INT(A2) -- HTH Bob Phillips "AWS" wrote in message ... I have cells with info like 1/6 and 2/2 etc Is it possible to have a Conditional Format Formula that will color cells with un-equal numbers (1/6, 3/4 etc) Red and cells with equal numbers (3/3, 1/1 etc) Light Green _______________________________ AWS |
#4
|
|||
|
|||
in conditional formatting, put condition 1 formula is: =RIGHT(A1,1)=LEFT(A1,1) and format to green condition 2 formula is: =left(a1,1)right(a1,1) and format to red. this assumes the data is in A1 -- tkaplan ------------------------------------------------------------------------ tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987 View this thread: http://www.excelforum.com/showthread...hreadid=470361 |
#5
|
|||
|
|||
That did the trick
Thanks _______________________________ AWS "tkaplan" wrote: in conditional formatting, put condition 1 formula is: =RIGHT(A1,1)=LEFT(A1,1) and format to green condition 2 formula is: =left(a1,1)right(a1,1) and format to red. this assumes the data is in A1 -- tkaplan ------------------------------------------------------------------------ tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987 View this thread: http://www.excelforum.com/showthread...hreadid=470361 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keep conditional format when "show pages" from Pivot table | Excel Discussion (Misc queries) | |||
How do I do a conditional format for numbers | Excel Worksheet Functions | |||
Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
Copying a conditional format | Excel Worksheet Functions |