Book1.xlsx
Pls help how to change column b font color based on column a values, as given in the attached file.
Book1.xlsx
Pls help how to change column b font color based on column a values, as given in the attached file.
hi
can you explian more
what should be the condition?
example - if column A<=100 column B should be "red"
once we know that we can put conditional formatting and choose color
for each cell in column a the value will be different
example
1
12
123
1234
Lookup information on Conditional Formatting where colour can be changed based on cell value "between" or "less than" values. This is easy to setup, HOME tab, CONDITIONAL FORMATTING selection, set new rule, select cell where value is based on, set colour format for range of values.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks