Format font colour based on another cell contents

[Thehub]

I'm trying to create a banking sheet and I need to change the font colour of two cells based on the contents of another cell eg:
The font colour of cells b1 and c1 is standard black and remain black unless cell a1 contains a value The cell font of b1 and b2 then change to another colour.
Would like to do this without resorting to VB if possible.
Thanks in advance to all who have a look at this.

 

[Joe4]

This can be done pretty easily with Conditional Formatting.
Just select cells B1 and B2, go to Conditional Formatting, choose the formula option (last one), and enter the formula:

=$A$1="your value"

where your value is whatever value you are looking for,
and then choose your desired formatting color.

 

[Thehub]

This can be done pretty easily with Conditional Formatting.
Just select cells B1 and B2, go to Conditional Formatting, choose the formula option (last one), and enter the formula:

=$A$1="your value"

where your value is whatever value you are looking for,
and then choose your desired formatting color.

That worked up to a point. I should have explained better. What I'm trying to create is a banking sheet that shows credits and debits and a balance. When the sheet is balanced against a statement the A cell will contain a letter. This changes the font colour in the B and B cells to the required colour. Sorry if I wasn't clear.

 

[Joe4]

So, is it that column A contains a single character or nothing?
If so, then try something like:

=LEN($A1)=1

for your Conditional Formatting Rule.

If that still does not help, please show us an actual example of what your data looks like.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[Thehub]

So, is it that column A contains a single character or nothing?
If so, then try something like:

=LEN($A1)=1

for your Conditional Formatting Rule.

If that still does not help, please show us an actual example of what your data looks like.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

Thank you. That worked perfectly.

 

[Joe4]

You are welcome.
Glad I was able to help.