Question description:
This user has given permission to use the problem statement for this
blog.
I need to conditional format cells
so if a cell contains a value the colour of other cells will change
Solved by I. J. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
12/02/2018 - 12:31
Hello! Welcome to Got It Pro-Excel.
Excelchat Expert
12/02/2018 - 12:32
Up there
Excelchat Expert
12/02/2018 - 12:32
Well, thanks for sharing me some of your data for us to make the conditional format
Excelchat Expert
12/02/2018 - 12:34
You may also copy a part of your data at our "Document Preview" for us to work on
User
12/02/2018 - 12:36
if c3 is less than 1 i need b3 to change colour to whit so not viable
Excelchat Expert
12/02/2018 - 12:37
Oh yes, can it be another color? like green or orange or yellow?
Excelchat Expert
12/02/2018 - 12:38
And less than 1 means, either equal to 0 or -1, right?
User
12/02/2018 - 12:39
yes it is black now but if c3 is less than 1 how do i change b3 font colour to white
Excelchat Expert
12/02/2018 - 12:39
We can set it up on the "Format" at the "Conditional formmatting"
Excelchat Expert
12/02/2018 - 12:40
We can set it to white over black if you want
User
12/02/2018 - 12:41
no how do i start with a colour then if c3 is <=0 chance to whit
Excelchat Expert
12/02/2018 - 12:42
Okay, here's the step
Excelchat Expert
12/02/2018 - 12:42
First, Highlight column B
Excelchat Expert
12/02/2018 - 12:43
Or select entire column B
Excelchat Expert
12/02/2018 - 12:43
Then click,"Format" menu at the top, then select "Conditional Formatting"
Excelchat Expert
12/02/2018 - 12:44
Then abox containing "A conditional format rules" will pop up at the right
Excelchat Expert
12/02/2018 - 12:44
ot it?
Excelchat Expert
12/02/2018 - 12:45
And the, at the custom cells, choose "Custom formula is"
Excelchat Expert
12/02/2018 - 12:45
Then put a formula that looks like this =C:C<1
Excelchat Expert
12/02/2018 - 12:46
Are you trying to do follow the steps now?
Excelchat Expert
12/02/2018 - 12:46
At the "Formatting Style" you may click the fill color into black or green or any color of your choice
Excelchat Expert
12/02/2018 - 12:48
So, you can also do white over black
Excelchat Expert
12/02/2018 - 12:48
Well, for your reference, please take a look at this Google sheet for us to see the screen wider
Excelchat Expert
12/02/2018 - 12:48
https://docs.google.com/spreadsheets/d/13FHgjQ6XulwK5cyqqlPclciD8ZKofKfbvB_53hcJ6X8/edit?usp=sharing
Excelchat Expert
12/02/2018 - 12:48
Please check the link above
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
