Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting - ajit
I want all values entered in a particular column to be blue or red if a cell
in that column is Sat or Sun e.g. if cell c3=Sat. all values in col C should be blue thanx ajit -- Knowledge is Power |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting - ajit
Format/ Conditional Formatting/ Formula is:
=COUNTIF(C:C,"Sat")0 and choose your format. Add: then include similar formula for Sun -- David Biddulph "Ajit Munj" wrote in message ... I want all values entered in a particular column to be blue or red if a cell in that column is Sat or Sun e.g. if cell c3=Sat. all values in col C should be blue thanx ajit -- Knowledge is Power |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting - ajit
It's working, Thanx. But did not get formula. Why there is 0?
-- Knowldege is Power "Ajit Munj" wrote: I want all values entered in a particular column to be blue or red if a cell in that column is Sat or Sun e.g. if cell c3=Sat. all values in col C should be blue thanx ajit -- Knowledge is Power |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting - ajit
If you want to reply to someone, it might be wise for you to quote at least
the relevant part of the message to which you were replying. As it is, we don't know what you're talking about. -- David Biddulph "Ajit Munj" wrote in message ... It's working, Thanx. But did not get formula. Why there is 0? -- Knowldege is Power "Ajit Munj" wrote: I want all values entered in a particular column to be blue or red if a cell in that column is Sat or Sun e.g. if cell c3=Sat. all values in col C should be blue thanx ajit -- Knowledge is Power |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional if -ajit | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
2 Conditional formats and insert comment - ajit | Excel Discussion (Misc queries) | |||
count conditional days - ajit | Excel Discussion (Misc queries) | |||
conditional sum - Ajit | Excel Discussion (Misc queries) |