Excel help please.

[Feriol]

I'm setting up a simple spreadsheet to record the results of an audit.
what i would like is to be able to turn an inputted number in a cell red if it is lower than the target, which is recorded in another cell.

Any help appreciated.

Thanks

 

[RHYDAL]

I'm setting up a simple spreadsheet to record the results of an audit.
what i would like is to be able to turn an inputted number in a cell red if it is lower than the target, which is recorded in another cell.

Any help appreciated.

Thanks

You'll need to venture into conditional formatting. Set a formula against the target and select the required format.

Not quite clear about what you want in the last bit?

 

[Darth Vodka]

I'm setting up a simple spreadsheet to record the results of an audit.
what i would like is to be able to turn an inputted number in a cell red if it is lower than the target, which is recorded in another cell.

Any help appreciated.

Thanks

if your inputted cell is b13 and you target e13...

on b13, go format>conditional formatting>formula is

=b13>$e$13

then stick a colour in the format

then use format painter to copy that down your range

 

[Feriol]

You'll need to venture into conditional formatting. Set a formula against the target and select the required format.

Not quite clear about what you want in the last bit?

Thanks.

I had looked in conditional formatting, and tried the 'format cells based on their values' but couldn't get that to work, and thought i'd need to do it with a formula.

Just done it on 'format only cells that contain' Didn't think that sounded like the right option, but once i checked it was easy.

Thank You.

 

[Feriol]

if your inputted cell is b13 and you target e13...

on b13, go format>conditional formatting>formula is

=b13>$e$13

then stick a colour in the format

then use format painter to copy that down your range

Thanks.

 

[Feriol]

More Help would be appreciated please.

I would like a formular to work out what percentage of cells in a range have a certain contents. the contents of the cells is preferably letters (eg 'H') as it makes assesing the information at a glance easier than numbers.

So i want a cell to show what percentage of a range contain H. If it helps the percentage value of each cell in each range is 0.45%

Any help on whether this is possible is much appreciated.

To Clarify, I'm Guessing its countif, but getting it as a percentage is the bit i can't work out.
Cells in the range could have a variety of letters, but only one for each cell.

 

[Feriol]

Also Countif isn't doing the sums, i wonder if this is because conditional formatting is in place for the cells its supposed to be calculating?