Excel - IF Function Problem - Expert Solution

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
Excelchat Expert 12/02/2018 - 12:48

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.