Cell Formatting Colours by Value

  • Thread starter Thread starter MTBer
  • Start date Start date
M

MTBer

Sat my MOUS Expert today and something came up that I had never seen o
heard of before.

A cell had to be formatted to be red if below a value and includ
brackets, whilst above the value it was coloured blue and withou
brackets.

This didn't use Conditional formatting, but was a custom format.

I solved it by manipulating an already present custom format, bu
really need to know how to do it now.

Thank
 
Hi
within custom format you can define up to three conditions to
differentiate custom formats (and include a font color). See the Excel
help for creating custom formats
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format Cell Number Options missing 5
Conditional Formatting - Excel 2003 2
format cells depending on value range 5
BULK Conditional Formatting - by column without going into each cell? 2
conditional Formatting help 2
Formatting appearance of Time Values 3
Conditional Formatting - Code to colour 3+ text values differently 3
Cell colour format according to date 1

Back
Top